How to: Move a worksheet to a new workbook.
Solution:
Select the worksheet to move. Select 'Move or Copy Sheet...' from the 'Edit' menu. Select '(new book)' as the destination workbook. Click 'OK'.
1) Select the worksheet to be moved.
NOTE: To select more than one worksheet, hold down CTRL while selecting additional sheet tabs.
2) Select the 'Edit' menu and select 'Move or Copy Sheet...'. (The Move or Copy dialog box appears.)
3) Select '(new book)' from the 'To Book' drop-down list.
Selecting new book
4) Click 'OK'. (A new workbook with the moved sheets is created automatically.)
